package com.flyu.dao.bill;

import com.flyu.pojo.Bill;
import com.flyu.pojo.Provider;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface BillDao {
    // 获取订单列表
    public List<Bill> getBillList(Connection connection, String productName, int providerId, int isPayment, int currentPageNo, int pageSize) throws SQLException;
    // 根据查询条件统计记录总数
    public int getBillCount(Connection connection, String productName, int providerId, int isPayment) throws SQLException;
    // 根据id删除订单
    public int delBillById(Connection connection, int billId) throws SQLException;
    // 根据id查询订单
    public Bill getBillById(Connection connection, int billId) throws SQLException;
    // 保存修改
    public int modifySave(Connection connection, Object[] params) throws SQLException;
    // 添加订单
    public int addBill(Connection connection, Bill bill) throws SQLException;
    // 根据供应商id，查询对应的订单
    public List<Bill> getBillByProid(Connection connection, int proid) throws SQLException;

}
